Hi , I am using Sql Data Sync to sync data from 2 tables in Sql server to azure.

it was working fine so far, but I started to get duplicates lately, can you please help me figure out why this is happening.

because the data sync tool is not very clear ,and I am not getting any error regarding the duplicates.

thanks,

christine

Hi,

May I please have your Subscription and Sync group id's ? 

Regards,

Mekh.

• Edited by Mekh SubbaMicrosoft contingent staff, Moderator 6 hours 39 minutes ago .

Hi,

May I please have your Subscription and Sync group id's ? 

Regards,

Mekh.

• Edited by Mekh SubbaMicrosoft contingent staff, Moderator 6 hours 24 minutes ago .

Hi,

May I please have your Subscription and Sync group id's ? 

Regards,

Mekh.

• Edited by Mekh SubbaMicrosoft contingent staff, Moderator Saturday, December 06, 2014 5:04 AM .

Hi,

May I please have your Subscription and Sync group id's ? 

Regards,

Mekh.

• Edited by Mekh SubbaMicrosoft contingent staff, Moderator Saturday, December 06, 2014 5:04 AM .

Hi,

May I please have your Subscription and Sync group id's ? 

Regards,

Mekh.

• Edited by Mekh SubbaMicrosoft contingent staff, Moderator Saturday, December 06, 2014 5:04 AM .

Hi,

May I please have your Subscription and Sync group id's ? 

Regards,

Mekh.

• Edited by Mekh SubbaMicrosoft contingent staff, Moderator Saturday, December 06, 2014 5:04 AM .

Hi,

May I please have your Subscription and Sync group id's ? 

Regards,

Mekh.

• Edited by Mekh SubbaMicrosoft contingent staff, Moderator Saturday, December 06, 2014 5:04 AM .

Hi,

May I please have your Subscription and Sync group id's ? 

Regards,

Mekh.

• Edited by Mekh SubbaMicrosoft contingent staff, Moderator Saturday, December 06, 2014 5:04 AM .

Hi Mekh,

My Subscription ID is :d958d4e6-ccb5-4fa8-b2a7-177ae9017b64

Sync group id:a5d69292-9e28-49b9-9afe-184307b76ab2_East US

Thank you,

Christine

Hi,

Thank you for the details.

I am trying to involve someone familiar with this topic to further look at this issue.

Regards,

Mekh.

Hi Christine,

Could you please provide more details of your problem? I'm not quiet understand what is "get duplicates" stands for. Thanks.

Regards,
Bowen

Hi Bowen,

I scheduled the data sync group that I created to run every 15 min.it synchronize data between a table in SQL Server and sql database in azure. the table in azure shows duplicates , like it is importing the data twice.

My understanding of data sync tool is that it sync incremental changes (changes that occurred since the last sync), I don't know if we can call it differential.

The log does not give any details about the process.

thanks,

Christine

you shouldn't be seeing duplicate records. The table will be getting a Primary Key violation inserting the same value.

can you confirm what you're Primary key is and re-check the your query that returns duplicates?

Hi,

Any updates on the issue?

Regards,

Mekh.

I have made some changes that I thought it may be the problem. I don't see any more duplicates.

Looks like this has fixed the problem.

thank you so much for your response and help.

Christine

• Marked as answer by Mekh SubbaMicrosoft contingent staff, Moderator Wednesday, December 17, 2014 4:17 AM

I have made some changes that I thought it may be the problem. I don't see any more duplicates.

Looks like this has fixed the problem.

thank you so much for your response and help.

Christine

• Marked as answer by Mekh SubbaMicrosoft contingent staff, Moderator Wednesday, December 17, 2014 4:17 AM

I have made some changes that I thought it may be the problem. I don't see any more duplicates.

Looks like this has fixed the problem.

thank you so much for your response and help.

Christine

• Marked as answer by Mekh SubbaMicrosoft contingent staff, Moderator Wednesday, December 17, 2014 4:17 AM

I have made some changes that I thought it may be the problem. I don't see any more duplicates.

Looks like this has fixed the problem.

thank you so much for your response and help.

Christine

• Marked as answer by Mekh SubbaMicrosoft contingent staff, Moderator Wednesday, December 17, 2014 4:17 AM

I have made some changes that I thought it may be the problem. I don't see any more duplicates.

Looks like this has fixed the problem.

thank you so much for your response and help.

Christine

• Marked as answer by Mekh SubbaMicrosoft contingent staff, Moderator Wednesday, December 17, 2014 4:17 AM

I have made some changes that I thought it may be the problem. I don't see any more duplicates.

Looks like this has fixed the problem.

thank you so much for your response and help.

Christine

• Marked as answer by Mekh SubbaMicrosoft contingent staff, Moderator 7 hours 27 minutes ago

I have made some changes that I thought it may be the problem. I don't see any more duplicates.

Looks like this has fixed the problem.

thank you so much for your response and help.

Christine

• Marked as answer by Mekh SubbaMicrosoft contingent staff, Moderator 7 hours 13 minutes ago

Hi,

I am glad you got the issue sorted. Would you be able to share the changes that you made?

Regards,

Mekh.